Adding tables and views to the warehouse schema

Use the Add Data window to add warehouse target tables, source tables, or source views to the selected warehouse schema. All tables in the Selected Tables list contain table icons on the Warehouse Schema Modeler canvas.

Authorities and privileges

To add tables to the warehouse schema:

1. Open the Add Data window.

2. To add tables, select the tables that should be part of the diagram from the Available Tables list, and click >. Click >> to move all the tables to the Selected Tables list.

To remove tables from the Selected Tables list, click <. To remove all tables from the Selected Tables list, click <<.

3. To create new source and target tables, right-click the Table folder in the Available Tables tree and select Define. The Define Warehouse Target Table or the Define Warehouse Source Table window opens.

4. Click OK to add the tables to the canvas and return to the Warehouse Schema Modeler window.

Related information

Warehouse Schema Modeler -- Overview

Defining target warehouses

Defining target warehouse tables

Defining warehouse sources

Defining warehouse source tables